Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_COL_PRIVS_MADE

`ALL_COL_PRIVS_MADE` describes the column object grants for which the current user is the object owner or grantor.

Related View

`USER_COL_PRIVS_MADE` describes the column object grants for which the current user is the object owner. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`GRANTEE` | `VARCHAR2(30)` | `NOT NULL` | Name of the user to whom access was granted
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the object
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the object
`COLUMN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the column
`GRANTOR` | `VARCHAR2(30)` | `NOT NULL` | Name of the user who performed the grant
`PRIVILEGE` | `VARCHAR2(40)` | `NOT NULL` | Privilege on the column
`GRANTABLE` | `VARCHAR2(3)` |  | Indicates whether the privilege was granted with the `GRANT OPTION` (`YES`) or not (`NO`)

See Also: "USER_COL_PRIVS_MADE"